SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532441 LIMIT 1 [ RunTime:0.000678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532441 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448375,909178,456218,242040,206867,714988,414379,573367,270944,299308,561252,659444,499335,738434,216084,215136,762354,479132,10524,756128,480694,404784,305584,188603,1047622,767872,634690,741756,104067,521604,175676,662777,1001809,972914,402627,437856,222421,13205,574337,950671,956960,1003536,918951,54284,940641,636008,178162,752760,216989,719587,338240,900365,547014,300038,536349,8620,205510,209911,230756,935333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]