SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255541 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255541 [ RunTime:0.001398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986438,988753,305760,186883,158481,250588,1045368,833214,171118,564765,680424,576757,773503,442728,930001,92425,470788,960120,481355,642352,120106,216685,127803,684971,217418,733133,785876,612478,955167,858792,493262,618764,981559,725823,353799,34972,176359,75106,548363,238648,240723,904131,742117,921883,66662,1004478,199448,813978,759267,734985,9366,241595,207532,957237,1024911,207838,662021,321920,445021,548717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]