SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583240 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583240 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269535,574790,923350,1011760,194704,1038714,995790,305830,589472,921274,152787,716094,136623,587426,977244,836715,443502,15472,710383,23475,825383,24556,782678,81236,300516,726789,318101,777008,293925,401208,628740,464276,1021802,157009,150457,434709,209516,308962,291277,402302,258685,148905,13130,223356,1018325,401547,241884,791961,889139,266085,342856,348617,1018343,352346,592737,961603,228189,489204,746732,487696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]