SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509104 LIMIT 1 [ RunTime:0.005554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509104 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455065,403496,922359,479193,982942,128712,552114,975920,723494,154426,17564,662824,668214,612977,741691,185516,826579,126575,116029,452377,1045559,361173,679987,254363,444500,570410,544776,626005,209418,120902,697145,620036,1009727,680982,38157,928979,691382,239289,480331,867420,532912,356181,163011,960027,262892,47446,231810,317267,760096,205982,483263,342139,79474,286322,300185,567419,224443,485176,366891,691424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001549s ]