SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509194 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509194 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971020,429836,442385,551162,181874,1030359,508655,711252,51731,331045,6735,103250,922436,43642,6571,45218,377512,845679,434434,655408,217539,724196,350822,698973,963960,68718,987590,1037784,357721,837786,149835,774620,484884,711081,53229,657429,401073,965537,905991,577372,771346,172240,669237,425652,543492,656003,245826,921469,246163,29676,10158,303190,464404,609605,804119,498050,765345,870483,581428,69029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]