SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457721 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457721 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362613,734197,273317,520841,52083,149426,482100,698054,239452,555820,40622,256386,548715,616030,390583,471642,606768,210725,384372,1048673,786432,128742,831929,969874,367129,161714,631612,58886,415583,298395,1041989,124984,849545,56936,217299,62438,952605,987402,918120,294810,805277,483987,387969,126021,445142,945406,733000,973753,403856,462462,153945,542097,741129,174173,986101,390963,127806,642499,453515,664977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]