SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3864 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3864 [ RunTime:0.003411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030642,1032734,249780,1007985,424563,211039,443140,303505,855979,350871,629927,1019947,899956,540333,141585,980280,536289,199394,881129,272611,1032459,593349,217798,328775,677160,558953,190480,29974,1030052,453998,1009848,849637,72012,940018,50136,399680,183426,887118,202152,617129,379823,211302,590861,35588,569893,316000,557008,956931,453084,456923,57089,782899,880669,91168,401277,159036,208492,988671,121858,271961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]