SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504701 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504701 [ RunTime:0.003680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88855,28256,560179,755073,416054,59874,245792,565475,727346,282385,631169,129699,711497,197909,258672,36653,310895,265090,8779,968692,741345,814512,270125,780555,571954,372199,721843,467012,681379,556636,255105,439331,1038580,1035249,714895,103206,798361,962938,53814,627568,722769,428751,674380,880357,363951,707742,753474,742033,696888,245875,383014,250032,555500,804785,701132,59177,222556,424292,63835,195135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000774s ]