SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984311 LIMIT 1 [ RunTime:0.001082s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984311 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521685,320088,570717,219721,1028290,170288,1037585,392579,837095,355456,662066,856392,65958,553286,911098,184719,846203,285629,40809,126459,725955,1023062,434920,666538,3939,991252,24203,760390,94828,225750,1044233,203500,96517,778229,1012604,242574,801226,1028891,160786,676132,126649,396058,817518,408970,519648,681409,820019,599991,1002057,584096,777452,5810,328145,301635,936108,239397,143010,744535,748292,306185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001020s ]