SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401299 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401299 [ RunTime:0.002053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036117,248954,826017,359603,905903,259005,736780,1037271,622129,483275,833380,397333,924444,44304,731819,356928,455255,1039245,31579,1028326,105177,720810,231802,132220,874497,452404,996738,621373,889281,323099,273379,655679,21567,933176,303003,871149,80430,218969,102108,837406,115825,628432,745588,454111,964258,583745,466185,685707,853484,773019,957504,87828,120056,711831,80247,70438,595850,196312,399343,697703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]