SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324731 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324731 [ RunTime:0.004930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970014,159280,60594,372120,692868,303001,351221,2373,465176,236878,920465,395497,498546,411431,935884,985973,1638,744561,108606,92264,522113,847352,475883,690108,246441,72864,402838,1019873,371298,694551,913122,472623,450964,531547,452595,111727,9387,507832,69739,550991,9491,788290,351653,558341,273819,1011579,420626,656310,717099,205492,769851,130517,572934,504732,1024427,264664,848988,430857,1030479,681293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001714s ]