SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409771 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409771 [ RunTime:0.002724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723742,389410,446830,241233,712333,524108,578256,37939,452894,9958,38946,466189,973693,810909,271380,287912,184650,73122,307717,712618,324035,581961,850545,808649,744751,528765,594240,635104,393869,353592,194850,373300,198723,465945,285468,779449,815381,632054,75368,1032170,909504,193863,619418,570282,861884,969549,309984,312121,962913,129056,166311,354305,48747,505385,219250,9853,446927,101700,484474,394198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]