SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004815s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403890 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403890 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945222,158204,674046,254759,488339,1044604,218963,614880,876505,689325,684935,75194,492148,61104,30812,1497,23264,984478,143345,947525,58063,407611,323903,157961,487055,105102,85191,607625,724115,906104,911885,152108,205874,167129,909667,673495,886615,867210,874365,724770,290825,800880,683715,516891,43142,726729,291866,996499,298491,41953,96851,357286,8244,501649,652544,374849,361159,582163,744641,810987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]