SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438809 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438809 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512030,78453,160461,575295,815128,232837,338793,221593,670767,893152,39495,561416,702199,1044123,852281,614836,364787,50262,607403,144500,524265,320650,993078,766645,721258,37911,674516,95268,856526,666183,1025632,750049,387137,559502,811043,870286,227212,789978,499400,726288,973412,437677,567056,169131,999478,670325,481946,476703,463423,113819,954310,617823,347158,663598,638999,96568,412515,199420,158536,133178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]