SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814013 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814013 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340763,991387,548421,149523,258752,703926,541930,265857,883933,480259,480346,608187,825668,1030138,857398,482610,34326,822217,453169,133073,573594,953015,398454,992532,446840,69339,488748,322111,507474,1021902,150125,566290,798393,415221,453973,837658,1018583,943421,625941,199178,471812,777371,145572,508133,999605,994276,277610,34001,195650,678296,604509,331457,292720,295679,601468,73212,419218,739300,240173,245846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]