SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 965328 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 965328 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475117,19664,179355,501077,454123,802992,459702,398664,1014847,427193,60354,1040853,899830,701069,71534,910108,2434,733698,46392,796492,569898,300797,877278,839802,239406,742844,111203,294989,278620,803752,625287,81121,545042,987861,954921,367492,227951,205044,695042,325141,205048,318148,1046542,330150,906367,124787,551573,912395,990825,342810,368718,958094,96350,384333,685213,524828,90716,668650,715231,41122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 965328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 965328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]