SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 923318 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 923318 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322089,102713,704870,666385,611773,101179,3669,144131,1036907,979124,1037003,1034773,278188,400803,779826,578073,445294,729138,397689,1036843,234081,177544,433896,90798,529046,565852,867272,152061,507724,66633,43438,729859,491122,112343,900435,924081,1004781,989318,532648,472320,1023341,531629,829856,1045650,895626,869789,754913,637362,1007492,36611,124350,54719,553073,479050,926990,225382,225866,9120,378245,689274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 923318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 923318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]