SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200423 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200423 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695569,421690,639521,638550,154331,397267,125313,214011,1029166,456127,233823,677817,922327,866263,209463,168635,964723,882432,787877,584758,361588,742704,333751,396174,959567,701769,559638,382502,558422,803409,170186,209918,30890,746399,764995,1034446,164142,71983,510965,228343,741535,880237,49133,728027,902290,997185,676769,372528,188610,866011,710945,324131,216721,201649,406171,286036,412103,60921,908680,160520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]