SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451658 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451658 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505867,159678,154322,835505,585389,990240,601538,902582,713625,184081,842418,716921,402495,379003,837193,111288,246647,669675,914001,291395,474199,325025,403565,279850,117337,285071,1026209,34840,105719,611670,981060,807809,304588,492155,142216,785876,739777,230333,436961,398737,642770,292683,736497,228731,707287,24487,957554,23443,901279,704424,346731,181597,946605,199444,634842,110347,353259,127047,85255,73358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]