SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039740 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039740 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739244,576159,730922,867049,291011,416493,296401,873822,506417,104338,99019,907159,356184,243475,269167,247274,646441,707953,1012879,272002,970097,873095,41682,614103,59794,915938,869394,691029,752989,937065,162897,930604,209280,424603,892568,720403,561882,113279,366646,955096,757386,31514,822247,147447,179367,63601,624766,690505,382637,104656,976315,523464,732276,786620,217679,771270,584477,702682,936275,266537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]