SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294167 LIMIT 1 [ RunTime:0.001241s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294167 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681235,263036,1033346,491036,713370,154168,979375,286094,177484,110016,891072,794562,791878,267264,787788,955272,265278,252753,724252,960210,486515,311440,1032496,974495,670021,160111,489025,925605,553243,1001117,899700,992628,6777,1045003,312954,269181,504052,558680,282087,226323,297826,459554,681429,317881,126611,1030760,306636,273399,911985,286666,4347,384722,328992,571278,766368,965215,78472,475135,300844,212985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001212s ]