SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409422 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409422 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281335,242472,412662,498245,500731,974510,570296,130370,940539,84921,2066,1001956,286821,802872,95168,913771,545677,402531,982597,84988,524006,585828,984363,452506,468655,888686,933009,462294,461867,642198,344270,774406,493647,67952,192018,286568,630872,91570,1017410,157491,841113,96753,679209,591694,816255,280878,722008,60990,267992,87419,375395,20046,1015987,129034,129983,251015,783575,298379,484251,422666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]