SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370540 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370540 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182208,228093,915458,90506,366705,860246,255061,509263,591310,188901,221814,377672,696307,579482,742760,806669,280146,711623,778956,606496,892035,663954,223694,97853,510423,228504,227549,469199,779924,110277,767056,500038,924778,759359,724822,961992,524151,390659,161214,675622,39702,964560,764725,313595,812480,931059,48314,914711,276399,74490,204227,113088,791515,487603,8144,313490,420870,545481,496445,1012968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]