SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598748 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598748 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666501,454805,527674,63274,568010,74297,845065,746540,464355,328167,957084,233265,283732,151736,483239,1042850,900766,662757,814925,1019500,143545,243993,736399,799574,164391,759249,601187,868453,853754,974628,458148,541595,741704,327006,540860,4471,221798,66125,199802,755986,523715,691446,312061,857967,41548,429680,984919,458107,250359,839584,794897,403540,220406,171968,1032403,222447,689872,843802,160208,979103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]