SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 359851 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 359851 [ RunTime:0.006426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741847,1038394,702962,255658,66412,649815,8679,954707,438369,830378,608038,794558,971336,61057,774356,33473,934231,277916,1039517,278822,430098,777105,72093,568500,469757,553572,359151,207876,293631,378659,397020,584440,321736,65768,761738,982124,369705,598731,237170,844417,199051,379139,811522,130969,403046,870418,902826,608728,589030,666042,334415,925736,823168,829639,321509,386136,453034,976021,129167,485526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 359851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 359851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]