SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409554 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409554 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823236,399917,812802,389785,19841,215533,596350,1010883,821769,1045291,433290,1027900,71268,443762,353681,662490,244693,58224,838102,116991,592213,816362,960832,141995,720299,527019,632789,294655,328865,640830,482701,236651,833317,274863,556318,694153,131649,262022,985543,678867,993127,154280,782017,356401,546454,737728,672121,897632,921505,61032,803798,475844,1041391,36159,58973,234821,289474,1030729,402543,753591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]