SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761141 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761141 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123270,190900,242228,454642,811018,863001,792253,672362,668275,777503,150323,679924,959860,520689,285880,431660,148323,902739,991034,362121,881052,323744,435543,813413,753396,720160,959225,493981,330789,841169,177622,413517,359432,137310,330363,369808,152784,257172,1013415,675556,402278,76859,603289,674092,774233,411729,332401,642093,790558,33357,488954,312606,112152,504656,500914,520060,488675,636160,289720,883251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]