SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356857 LIMIT 1 [ RunTime:0.004822s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356857 [ RunTime:0.002888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308824,646481,654522,679839,124943,757668,139081,854770,209257,374855,1027516,974039,791482,249154,774355,18974,380773,709716,757233,211918,263300,239717,552979,962025,735457,127591,364253,901471,259495,941769,297128,908484,521896,459422,25871,145867,120244,819931,336937,1024978,467949,234676,119969,817825,373614,988638,718288,97289,680284,436050,238897,68422,343889,850472,288184,671538,901849,1013118,912488,539077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001837s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]