SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382867 LIMIT 1 [ RunTime:0.000792s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382867 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018974,688188,70948,601396,666380,27093,897895,1041219,465875,49294,765076,886712,525632,1033439,1031749,962756,707034,175006,875295,499553,495446,857486,16179,404565,264613,42204,786020,402715,245848,753976,73903,807650,808716,300345,488551,961675,601947,578892,791294,932658,683820,43707,281762,93950,1044713,7904,608116,693513,136654,625646,808131,478174,84738,920679,661179,686957,883712,21542,189166,631610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382867 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382867 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001082s ]