SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029143 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029143 [ RunTime:0.002676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421794,1003271,266097,628921,982773,977766,651290,298282,305145,776015,98871,456182,898100,878099,935152,669053,9453,101691,971520,844616,420346,929987,671192,839541,701685,683055,906740,869221,1032806,460447,228351,834108,799578,80077,454289,336907,767936,238840,434406,209700,276426,133942,62821,137331,990030,996137,505506,439058,273189,195962,481171,907695,320417,691858,186755,134869,585427,47581,860095,666788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]