SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 359047 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 359047 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518767,977698,529787,115610,476346,988110,449029,560439,142424,133581,165971,628291,458710,875392,143269,578173,875243,433579,412418,926528,25199,965532,291256,660484,428569,530131,345306,352892,488844,350867,193641,19281,271229,875871,914036,828218,361937,1014100,34351,302106,310979,309412,684795,48227,734721,502503,19340,914390,701429,303328,182205,522210,187465,348571,1003038,156805,457225,253392,414848,222780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 359047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 359047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000932s ]