SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101230 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101230 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626450,252575,781537,677546,575170,490070,321104,375758,687592,196951,751712,799026,691897,608814,818211,522775,309481,529509,503864,583869,1553,129594,625966,95647,40202,869349,417490,265802,114841,938770,599181,195943,371493,836629,336798,494852,182772,424617,374067,316385,811243,78769,279036,719669,983057,689545,977769,535097,347798,227474,330338,603615,161562,669224,989351,741188,978863,15853,816795,1012941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]