SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540934 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540934 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480940,667634,171779,907490,495562,562101,487473,229717,503334,395186,1036749,541472,1016235,880070,651971,923066,594405,589492,640438,837606,878581,211092,32040,819529,1011264,909657,144058,968951,65831,1012096,741132,715117,738741,681599,1030785,371071,318479,420249,335475,618176,628545,156616,401841,151952,284224,975444,721268,137257,259519,500815,168331,633281,84048,433850,818700,616018,829865,1035821,66687,312945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]