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` = 104314 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104314 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522525,604256,758664,259843,387153,350862,929950,561607,158037,67899,1022889,63147,91446,638748,45266,160454,420090,617679,124404,695871,364442,686449,672615,427214,281166,712303,845609,188867,600195,976442,191937,41871,981022,765458,531821,646700,880875,32781,377516,683685,668716,388992,259460,1046575,896096,131390,382253,997661,126369,196240,882580,220528,424465,199373,631499,727293,225649,823224,733965,579496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]