SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568036 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568036 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788011,273098,26323,628607,577170,975991,318989,468279,529843,405080,409985,371513,661303,396612,855105,406597,492249,29173,165140,97004,1025249,653488,460097,951365,303331,71954,808194,157067,656163,765897,704328,284718,889120,199081,375619,649516,924610,75828,740549,209593,627168,831390,969532,394009,991925,13182,905914,974833,821455,280275,814382,789379,520061,453331,5656,545177,888848,442422,327931,157062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]