SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540138 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540138 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584258,172509,44645,158539,237262,5686,597781,695663,771371,5720,859394,559104,308121,409730,200085,194511,268178,532078,736968,26407,608336,266051,374106,768251,814169,348620,140521,883743,593997,923830,688866,609672,681338,223508,401568,208985,487078,694834,762367,235361,1003223,529076,726469,91287,501391,679151,204751,510787,801801,701252,512092,28937,45663,728749,244008,923137,653265,109558,451655,685667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]