SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042605 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042605 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68709,570191,926709,451184,645681,152147,1041761,786987,300534,295404,626225,552176,595692,556881,326904,734131,511637,267309,1028129,623333,870893,69450,720455,994899,412883,361390,871790,275555,913840,705771,433169,695184,466821,199800,390444,423837,21427,677784,880135,167678,880422,344165,741088,868221,818252,421941,320919,183741,547112,209726,505905,502904,394180,844993,156749,900746,459248,284135,539127,695982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]