SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042828 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042828 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530246,723012,13191,595266,328780,457181,666429,662490,422733,601220,443521,419946,534428,394004,610946,606463,306716,189008,449951,596240,962472,315792,840213,868337,926095,900022,519456,116610,1039586,852734,41511,187005,55091,762860,508134,214044,979797,367235,955810,571359,285823,411786,576820,840763,969756,712085,825908,105835,109352,428829,112782,962176,493113,166935,863199,884688,486918,51149,442355,770458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000351s ]