SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017204 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017204 [ RunTime:0.003157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896746,861131,516821,993337,170757,986548,368203,408256,812151,402448,540042,757951,310648,854641,743139,623834,365505,771882,492369,256297,513121,737199,46945,672029,154693,686923,249124,282023,90200,376803,297518,990351,1034162,305461,349103,898915,977141,81589,1018832,1041518,1037118,389,142852,567913,1013585,56128,402588,691272,272330,665699,103176,758410,458039,804951,1031904,18362,861654,40308,218424,559785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]