SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296814 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296814 [ RunTime:0.002955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253661,412944,721009,566249,241159,999235,281430,1013946,541879,567465,121455,105387,944884,260224,216199,334126,749689,361590,20491,266144,200235,405426,348052,338642,891582,420876,938771,526444,760998,531981,304859,357960,690211,703304,22127,379560,516014,222,1019073,580516,942869,1047018,669354,213262,559443,91109,962973,214444,784135,997665,777884,904576,260927,619375,196873,907016,644171,744077,101716,106758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004277s ]