SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003057s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014352 LIMIT 1 [ RunTime:0.001230s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014352 [ RunTime:0.003158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148160,39586,173743,440413,356230,987645,87514,434467,234756,458110,771152,699539,1048209,188272,859454,671069,493598,247075,807563,445356,20074,948350,757821,21504,782047,278585,494287,297112,482403,1020815,678411,78092,571394,343187,41899,322302,738323,454939,278357,731211,644104,839167,397879,465860,249717,895775,218761,636050,386783,254388,1017376,562597,170396,996982,716021,614753,187408,345399,13023,982443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]