SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401984 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401984 [ RunTime:0.002758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513530,345066,839811,19682,934056,487589,303026,13317,657889,391233,140293,1037058,82986,555292,1033268,423862,592587,1017326,157544,812044,707722,84357,614,489771,939850,295939,490172,858470,121341,210417,32136,371898,797999,614942,375254,594930,501013,582016,108867,894577,853337,449990,306405,764070,738757,307211,747728,336675,950245,1013580,651443,455669,1042247,650315,30471,947034,1000597,423479,235728,252527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001978s ]