SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002620s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397218 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397218 [ RunTime:0.004941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748244,656429,887732,300888,424557,510091,774762,239413,1029877,680442,442889,1030065,556734,616820,699467,551786,348894,861978,610989,156387,58217,625339,762797,157833,956824,485494,40884,1047360,680551,906443,723901,592749,85749,167526,1010635,639426,345302,191628,543334,313061,723198,666852,15675,690257,34927,249314,428318,924293,373941,162893,154152,40660,1016241,371299,866356,620017,73370,991201,678071,916362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001897s ]