SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423284 LIMIT 1 [ RunTime:0.001064s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423284 [ RunTime:0.003979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77941,526906,941371,38565,523424,72579,349416,620438,103544,150275,332761,908347,824395,463109,736242,33101,482198,909348,444090,640588,173346,72182,322737,783152,73446,734513,689790,282895,623141,830973,291986,837609,240725,700562,614996,478218,168451,560479,270817,592652,157337,761117,244016,194940,908025,105540,232980,54787,299552,305478,434984,485491,640872,636900,993879,780411,201751,923486,270345,87030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]