SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505994 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505994 [ RunTime:0.003278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167659,708528,343233,413255,64425,21638,275684,995991,559256,628688,1025002,191658,130060,293817,77009,392689,604204,222031,208861,810269,771521,907484,527237,370931,844445,386461,226227,892977,593153,417098,960519,929384,168408,549980,981727,1048706,67291,974963,875647,952391,479618,615554,739651,151909,558708,729151,199308,89257,58549,897254,833682,565418,194700,112409,927042,337255,271683,177271,545657,365744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]