SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30060 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30060 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499235,367503,406586,188349,184887,919843,167576,714952,1019575,549890,930263,1020026,137668,977766,903203,74540,608757,782253,507893,891465,490344,909378,513523,872499,364877,739720,815985,329990,265232,216284,202548,253414,1030223,638756,84380,796803,117646,667114,865745,506248,358481,1011772,1576,359668,585424,561051,532629,1001953,834890,568339,964373,160863,803094,819514,334852,900824,176470,882170,294893,830932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]