SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041157 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041157 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010583,1042530,1027679,264094,8150,582599,649480,364529,690445,173323,591403,987613,683914,821791,657259,704153,445902,8819,879703,282448,169611,401594,170742,985864,355379,832138,220152,552208,597223,484037,795364,753000,745158,368045,216835,47736,924256,586407,284881,957951,952930,162792,448587,917025,531637,44918,565690,294766,375571,354597,179143,646206,260211,921938,434208,40501,466907,206748,65735,695063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002341s ]