SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402045 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402045 [ RunTime:0.002996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317963,879208,131640,544031,524972,702362,967968,762260,217985,94229,919688,489049,34701,716547,442669,1008224,5148,640291,820983,494728,280439,804533,82178,695512,854363,731278,129918,447477,547105,744010,1014918,751038,906447,428857,765448,383610,342717,884826,712036,677917,1016303,599144,10981,768518,83422,371970,607428,25155,952062,910659,576178,604314,180292,813956,427107,349829,253745,652577,895777,460367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]