SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407647 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407647 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359217,359553,590514,658671,736898,537162,624169,754880,596995,294372,1048427,949418,868466,630410,578105,812367,130832,689683,538317,693784,308238,838836,649008,43815,139711,399499,522679,552480,815033,767114,180673,227285,658285,889901,1047095,245396,453111,632147,683554,382710,508312,250389,618969,661931,894923,352245,663141,617364,792186,387161,58963,358040,43175,41052,356570,843324,15861,566834,243528,279962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]