SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508302 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508302 [ RunTime:0.004704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522581,827353,16623,566586,636982,102999,176967,1044000,915056,99095,429602,744180,561204,33256,658264,401742,641412,603433,430654,91441,911348,968666,616090,455830,738325,843158,614900,438897,717160,69450,1004211,1011934,178386,820159,309916,587692,768513,417012,898533,237552,789254,760072,934368,1036336,932553,934346,578705,326349,441463,30217,467039,990562,315395,831183,516419,835704,11180,631121,901015,590997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002538s ]