SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543284 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543284 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255420,8030,797382,716140,336747,452840,932845,693806,181027,498433,496661,529434,331573,703053,616327,301091,316425,498209,209309,974610,405685,717552,145112,793882,208197,1003399,321451,15588,510263,885188,926788,283869,760964,990344,708346,562438,495326,213215,1000813,729206,792491,672203,306426,74974,692711,210389,802570,314365,27435,48431,597433,9678,882763,42714,41516,603287,199566,805235,46506,950908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]