SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439511 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439511 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517916,956223,169955,934278,595468,454203,1003228,981958,640886,910955,409545,915825,945043,929191,219528,39710,984750,573142,576154,324354,342844,523488,152604,302511,60761,168559,123111,248681,1045745,1006749,46477,292831,868260,104312,485456,1023393,755732,388088,520996,466396,622114,26084,453419,257420,95599,731373,854291,1034853,508399,263691,750686,43394,254410,1012955,405856,340881,22436,814576,295375,555511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002698s ]