SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455276 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455276 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904574,216407,190477,961955,452144,697212,301401,1042483,555561,118985,154744,59627,430848,469238,865910,199385,464322,159675,919616,988867,337616,60992,469757,847042,824317,603246,31062,761059,764375,235218,834765,15322,1010586,521147,417839,744662,107501,970329,431875,143493,781386,109087,487753,955875,662099,24590,193835,744054,240831,842609,89116,669725,49090,533411,712518,189060,631039,248535,287399,641040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]