SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50999 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50999 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107544,1022333,1028299,928643,181827,829154,110487,286348,108956,615243,16837,757560,41335,756470,559491,1012209,250930,706627,438235,1027264,396423,815916,396987,238580,767190,260495,678565,287425,830812,96756,217641,523941,1038116,399243,842770,21006,559248,206950,406429,182617,89941,124012,253945,640367,313723,523719,388502,576091,929497,75990,453229,247733,355663,438036,500034,537289,829530,84639,343975,887328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]