SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535605 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535605 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903193,409083,639157,302798,46855,60813,437228,730252,235782,836989,480884,1027392,564772,22386,25206,187911,935943,200861,867604,373106,964886,29616,169005,590554,211375,50300,1029790,802377,1011094,421134,435215,521653,754355,716237,563660,507414,570600,587782,198083,60383,43805,275375,792721,787925,602704,160512,828429,979406,206379,249617,1019793,479719,332663,446150,26800,732250,820406,284257,207757,357939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]