SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261036 LIMIT 1 [ RunTime:0.002192s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261036 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914475,481786,692043,1048645,549530,553166,435186,271131,531860,386399,40161,1034859,71878,670417,796937,823381,885131,389439,346389,454026,651075,546623,681646,406860,382501,474813,1019942,519085,575698,688795,396656,133119,532177,290035,165453,741008,343767,977743,766132,412997,1027248,957419,90527,712871,406413,786998,315470,233092,733507,207405,904499,267973,565098,340567,1001251,99274,883632,320417,295055,689053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]