SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201234 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201234 [ RunTime:0.002580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61651,825910,622739,941115,289052,4749,829830,498089,589122,309814,262794,526525,438545,1030526,978300,910222,91474,755495,694329,656976,953094,612622,842056,601296,214411,1005099,572961,933396,910791,386891,752766,746065,824721,681534,1040260,922369,394780,536638,488493,996797,238321,660011,434438,465721,832106,574195,62226,981735,97623,641348,74790,1033980,837006,957761,20320,997827,847990,601638,922027,395400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]