SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417505 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417505 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833395,309940,1026857,907708,645096,365337,489812,130401,363362,363652,326684,806232,621697,1020418,108086,34400,939862,643702,109217,693021,183858,661476,124748,336057,749601,178534,496408,361125,3429,10969,531677,60891,157320,59348,181169,352987,287048,435691,11542,551720,290597,693949,772427,369612,122197,620087,441054,411928,877210,603320,704639,57208,578026,761246,357102,331465,916798,903222,441025,16095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]