SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526680 LIMIT 1 [ RunTime:0.000659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526680 [ RunTime:0.003031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454954,166686,501998,835300,106587,438033,429769,1024520,695099,133134,944708,660253,852699,900633,481938,362028,721691,232696,778099,180427,710393,334319,945780,579713,90101,589727,435681,517578,588672,1034978,103609,387786,31261,285469,239314,169620,294461,185300,416980,947164,568321,481173,331030,899641,778952,698925,684569,15860,580286,375866,1044340,678524,292954,479878,886360,910095,874033,112573,293756,213181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]