SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410564 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410564 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272901,434038,652452,285083,554997,142762,370337,249313,283392,279963,283001,705572,429670,488389,488276,837710,727011,892732,534508,787836,830939,356758,346280,779152,664099,211377,956459,25866,930366,775601,632031,1005195,416220,723569,917802,1029408,1035312,610955,478372,725102,419097,384279,871074,466383,458741,754378,71274,573392,5070,501628,361203,195691,940427,314533,780401,786493,656204,679250,768790,969185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]