SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346513 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346513 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320965,184877,404051,348440,745934,896376,267706,310967,758752,789129,24833,50062,64276,113709,43969,165866,295423,230197,963954,820170,94876,301030,132961,89894,782471,335122,170069,822473,351976,687829,274860,238827,125260,474509,773595,750664,817943,958201,216582,276621,142422,241720,411771,441487,929731,50022,577503,983603,743518,723512,652153,940807,252523,834154,664540,161266,700085,71093,956538,696275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]