SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250371 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250371 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509251,176977,948974,171455,4877,711236,1029827,979400,687568,22136,550308,440320,529484,458239,779213,5448,83106,501440,476008,528158,876326,564976,190109,616534,570750,716988,684150,484287,535451,689778,817393,42472,880495,229632,314176,516327,831023,129839,448672,410290,567793,754635,579800,444312,624685,35032,498726,19763,838909,226886,1031395,263660,152252,326732,373509,375326,560087,142425,209697,339733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]