SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002725s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427900 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427900 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39885,841734,540025,57794,913761,392012,379356,869943,301364,290054,719861,510594,283310,698175,100509,488391,786248,388892,533895,135240,174686,820386,393935,813492,20937,201411,770936,505342,893643,64197,877607,1010565,116078,752395,856013,648464,884489,729430,687549,818280,370161,598107,430979,738382,26775,367945,641600,805928,671597,127839,394643,693925,398761,485891,906712,990561,786168,180982,1030612,185497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001363s ]