SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452681 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452681 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590842,342555,504450,131768,321896,491552,287135,108845,344014,154082,348944,290169,1008496,653366,781904,677065,301880,1034786,860196,948977,835943,960621,944900,592311,467132,866874,459265,109871,985225,787566,796005,496531,406503,209906,788165,689115,713504,1031791,376831,224233,214189,1041335,466955,759745,713447,518169,181577,827661,162011,804538,471955,456533,767884,893497,925774,9390,291267,228037,827318,96971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]