SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001871s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328018 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328018 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970743,601232,661448,76737,802687,891720,264343,317876,550989,145797,997661,69400,51222,24381,491612,830634,78413,97421,876821,386959,459278,62418,874820,59146,868973,622307,368036,20348,93875,53053,851891,907440,929614,800402,250123,695142,725270,480462,72780,803013,549992,174853,450020,535523,954644,900840,705140,847636,777661,873282,683987,433319,812664,782980,981993,141829,651009,915868,239971,1031443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]