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` = 1017141 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017141 [ RunTime:0.005752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635095,700096,694058,135685,265003,901385,13717,140663,629846,229741,563346,439074,520769,360993,475036,460622,876171,601735,602005,201145,1040129,700298,500230,240948,503543,929630,570498,396705,784761,193679,376492,983345,423050,297228,411594,565088,136712,463982,492198,826126,333728,969378,579989,325291,483559,707852,1037810,173806,151361,854609,250418,172859,532543,563440,490919,697883,321909,282140,133753,40065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]