SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532728 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532728 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719072,53663,638643,931561,662393,206217,988321,165421,942875,57625,8683,793831,603540,13102,415814,959390,813894,761768,62586,202805,489337,761586,378959,989186,800992,349351,36692,143297,716852,461457,412526,899511,213001,977716,273728,651280,503042,840967,632279,921753,792484,599858,1024868,309725,961224,84923,803830,236915,116531,672730,696821,377275,455609,566215,894938,421095,284692,820817,526093,111217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]