SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 258454 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 258454 [ RunTime:0.003635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744685,298122,480785,38716,246166,249662,192075,140653,558820,460460,514137,911883,654818,860710,660980,996548,549166,193750,1006320,598201,911903,515247,981986,450130,121299,684702,857139,165894,212601,555789,630329,924214,263636,280471,176952,691869,340628,901929,409951,540097,339617,447626,143792,214687,326253,386047,856454,296110,776032,904309,559178,540185,137570,132389,908801,602634,121433,260329,114859,998747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 258454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 258454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]