SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14012 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14012 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455941,952181,1035097,542752,489103,194625,187207,563135,240580,175238,634464,252636,149578,493718,410552,205644,751669,199104,674694,571294,244898,1043133,120721,232745,87471,808088,96215,659317,220633,113661,978224,426736,315571,623865,459009,359772,13112,762162,721802,491728,702313,412876,366844,692482,946580,751282,527292,914024,811358,973338,331750,375300,426740,1859,9573,514691,557639,321505,543515,988622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]