SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38083 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38083 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283633,999694,268112,487518,653385,494453,82302,929206,883964,656567,923194,590782,417081,920549,408041,606656,579373,607670,676323,825294,398706,108952,24880,180547,33723,554115,774195,367765,276154,483323,83789,752292,39042,274832,419023,563934,1031771,857440,574406,281120,988898,772468,448571,527421,161213,829295,451366,594307,528163,960197,991841,1015513,697608,155927,449428,472476,227660,595813,478704,159686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]