SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354370 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354370 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289749,733799,916380,8807,231464,882451,131343,206218,901365,199371,1018754,1003474,799175,854165,235164,808764,6665,668389,130469,545823,158989,750686,565136,144672,340578,67486,196802,373636,760701,554795,547970,957543,635050,182050,244535,46249,152578,367923,1027029,374131,740757,712147,849363,372691,421918,321392,629880,617801,330005,51176,1017577,583381,439109,685837,441616,857612,152079,375650,43640,916896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]