SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034152 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034152 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206045,569940,1022136,578013,336133,558329,726006,47761,606858,951577,511852,20387,665029,1011477,975824,348034,484742,728787,879983,929798,228632,636089,875700,857965,829644,502772,674864,652607,627588,611793,398280,695438,16102,899772,93451,920215,852974,756983,142281,20082,1038716,207269,989821,846412,289466,140596,929219,398808,209336,873726,1010343,862797,60052,286059,363324,929592,152153,915795,478950,976977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]