SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567057 LIMIT 1 [ RunTime:0.002017s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567057 [ RunTime:0.006750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416010,76183,948427,610700,770558,458924,351590,869172,321728,393726,772816,416709,614060,63571,862644,877085,34364,630800,71934,565435,563653,941623,231252,206111,718,369315,550806,151590,786651,764116,186499,580607,157131,8266,1004999,256300,151541,899606,195367,427459,74071,788907,242418,1032452,184667,682401,562624,1016922,382263,190536,687817,988418,1032253,247104,641434,451596,1029384,1045459,764439,629287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]