SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036076 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036076 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554105,260435,740096,695819,514690,311454,230193,488493,890055,954008,541527,1026192,374238,1013111,955408,99370,833574,674440,632176,168267,794124,1022826,872275,929874,583777,490818,629262,752824,744964,527854,729865,884745,911961,183014,937776,664873,179884,609863,976043,841552,279979,114623,277977,1041365,916020,168373,175397,7254,236106,996170,65798,673349,793541,204312,421519,56775,269582,571158,270569,247703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]