SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489303 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489303 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652353,416400,333309,253713,588758,217922,347190,844303,41383,527511,979515,291615,70698,1041899,398122,631116,920154,325210,417068,794170,924412,548649,644105,496368,194098,550853,89679,938883,352215,920193,1046860,292746,521523,745683,491558,106874,820586,257784,749943,574936,839249,367866,686500,122795,805912,817124,669854,975867,60078,993434,840276,202938,52528,915775,239636,60589,683835,283258,597510,278244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]