SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4301 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4301 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320766,680535,667870,180805,800605,936541,961154,202255,600926,187771,439904,822240,609739,637403,318689,824155,183336,828419,107476,419160,406059,213796,780559,656609,689998,97689,50885,657475,752084,160864,391761,747608,882532,449448,1008699,203474,832220,716682,224046,124404,492458,394504,987685,578067,715540,246444,800190,890282,19133,626340,435512,323843,675252,166381,903590,545837,587191,190902,385779,161065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]